#! /usr/bin/env python
#  -*- coding:utf8 -*-
# fileinfo: test some function
import sqlite3

database = 'economic_data.db'
conn = sqlite3.connect(database)
cursor = conn.cursor()
sqlstring = '''
CREATE TABLE e_price_au_rmb_gh(
    ID INTEGER PRIMARY KEY autoincrement,
    BANK_BUY REAL,
    BANK_SELL REAL,
    PRICE_TIME TIMESTAMP
)
'''
cursor.execute(sqlstring)
conn.commit()
conn.close()